public class QueryUtil {

    private String queryAllSql = "SELECT * FROM ";
    private String queryStudentScoreByTeacher = "SELECT s1.name AS teacher, s2.name AS class_name, s3.name AS student, s2.score FROM " +
            "teacher AS s1 JOIN class AS s2 JOIN student AS s3 " +
            "ON s1.teacher_id=s2.teacher_id AND s2.student_id=s3.student_id AND s1.name=?";
    private String queryStudentScoreByNameSql = "SELECT s1.name, s2.name AS class_name, s2.score FROM student AS s1 JOIN class AS s2 " +
            "ON s1.student_id=s2.student_id AND s1.name=?";
    private String queryClassByName = "SELECT * FROM class WHERE name=?";
    private String queryClassByTeacher = "SELECT * FROM class WHERE teacher_id=(SELECT teacher_id FROM teacher WHERE name=?)";
    private String queryTeacherByNameSql = "SELECT * FROM teacher WHERE name=?";


    public String getQueryAllSql(){
        return queryAllSql;
    }

    public String getQueryStudentScoreByNameSql(){
        return queryStudentScoreByNameSql;
    }

    public String getQueryClassByTeacherSql(){
        return queryClassByTeacher;
    }

    public String getQueryStudentScoreByTeacherSql(){
        return queryStudentScoreByTeacher;
    }

    public String getQueryClassByNameSql(){
        return queryClassByName;
    }

    public String getQueryTeacherByNameSql(){
        return queryTeacherByNameSql;
    }
}
